Dataset statistics
| Number of variables | 26 |
|---|---|
| Number of observations | 128655 |
| Missing cells | 23634 |
| Missing cells (%) | 0.7% |
| Duplicate rows | 0 |
| Duplicate rows (%) | 0.0% |
| Total size in memory | 25.5 MiB |
| Average record size in memory | 208.0 B |
Variable types
| NUM | 14 |
|---|---|
| CAT | 9 |
| DATE | 3 |
Reproduction
| Analysis started | 2021-01-30 07:11:53.156256 |
|---|---|
| Analysis finished | 2021-01-30 07:13:08.903154 |
| Duration | 1 minute and 15.75 seconds |
| Version | pandas-profiling v2.8.0 |
| Command line | pandas_profiling --config_file config.yaml [YOUR_FILE.csv] |
| Download configuration | config.yaml |
Area has a high cardinality: 92 distinct values | High cardinality |
City has a high cardinality: 488 distinct values | High cardinality |
DisbursalAmount is highly correlated with AmountFinance | High correlation |
AmountFinance is highly correlated with DisbursalAmount | High correlation |
Area has 11653 (9.1%) missing values | Missing |
City has 11256 (8.7%) missing values | Missing |
MonthlyIncome is highly skewed (γ1 = 357.3273301) | Skewed |
ID has unique values | Unique |
AssetID has unique values | Unique |
| Distinct count | 128655 |
|---|---|
| Unique (%) | 100.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 70965.32655551669 |
|---|---|
| Minimum | 1 |
| Maximum | 143395 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 1005.1 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 6932.7 |
| Q1 | 34408.5 |
| median | 70988 |
| Q3 | 106549.5 |
| 95-th percentile | 136475.3 |
| Maximum | 143395 |
| Range | 143394 |
| Interquartile range (IQR) | 72141 |
Descriptive statistics
| Standard deviation | 41762.77928 |
|---|---|
| Coefficient of variation (CV) | 0.5884955557 |
| Kurtosis | -1.220605837 |
| Mean | 70965.32656 |
| Median Absolute Deviation (MAD) | 36079 |
| Skewness | 0.03192695249 |
| Sum | 9130044088 |
| Variance | 1744129734 |
| Value | Count | Frequency (%) | |
| 2047 | 1 | < 0.1% | |
| 140654 | 1 | < 0.1% | |
| 62772 | 1 | < 0.1% | |
| 64821 | 1 | < 0.1% | |
| 58678 | 1 | < 0.1% | |
| 60727 | 1 | < 0.1% | |
| 38200 | 1 | < 0.1% | |
| 40249 | 1 | < 0.1% | |
| 34106 | 1 | < 0.1% | |
| 48445 | 1 | < 0.1% | |
| Other values (128645) | 128645 | > 99.9% |
| Value | Count | Frequency (%) | |
| 1 | 1 | < 0.1% | |
| 2 | 1 | < 0.1% | |
| 3 | 1 | < 0.1% | |
| 7 | 1 | < 0.1% | |
| 8 | 1 | < 0.1% |
| Value | Count | Frequency (%) | |
| 143395 | 1 | < 0.1% | |
| 143394 | 1 | < 0.1% | |
| 143393 | 1 | < 0.1% | |
| 143391 | 1 | < 0.1% | |
| 143390 | 1 | < 0.1% |
Frequency
Categorical
| Distinct count | 4 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1005.1 KiB |
| Half Yearly | |
|---|---|
| Monthly | |
| Quatrly | |
| BI-Monthly | 462 |
| Value | Count | Frequency (%) | |
| Half Yearly | 76248 | 59.3% | |
| Monthly | 31150 | 24.2% | |
| Quatrly | 20795 | 16.2% | |
| BI-Monthly | 462 | 0.4% |
Length
| Max length | 11 |
|---|---|
| Median length | 11 |
| Mean length | 9.381392095 |
| Min length | 7 |
InstlmentMode
Categorical
| Distinct count | 2 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1005.1 KiB |
| Arrear | |
|---|---|
| Advance | 6306 |
| Value | Count | Frequency (%) | |
| Arrear | 122349 | 95.1% | |
| Advance | 6306 | 4.9% |
Length
| Max length | 7 |
|---|---|
| Median length | 6 |
| Mean length | 6.049014807 |
| Min length | 6 |
LoanStatus
Categorical
| Distinct count | 2 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1005.1 KiB |
| Closed | |
|---|---|
| Active |
| Value | Count | Frequency (%) | |
| Closed | 94457 | 73.4% | |
| Active | 34198 | 26.6% |
Length
| Max length | 6 |
|---|---|
| Median length | 6 |
| Mean length | 6 |
| Min length | 6 |
PaymentMode
Categorical
| Distinct count | 11 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1005.1 KiB |
| Direct Debit | |
|---|---|
| ECS | |
| PDC | |
| Billed | |
| PDC_E | |
| Other values (6) | 2459 |
| Value | Count | Frequency (%) | |
| Direct Debit | 31766 | 24.7% | |
| ECS | 31390 | 24.4% | |
| PDC | 26617 | 20.7% | |
| Billed | 26486 | 20.6% | |
| PDC_E | 9937 | 7.7% | |
| Auto Debit | 843 | 0.7% | |
| SI Reject | 744 | 0.6% | |
| Cheque | 442 | 0.3% | |
| ECS Reject | 417 | 0.3% | |
| Escrow | 7 | < 0.1% |
Length
| Max length | 12 |
|---|---|
| Median length | 5 |
| Mean length | 6.108305157 |
| Min length | 3 |
BranchID
Real number (ℝ≥0)
| Distinct count | 189 |
|---|---|
| Unique (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 166.28967393416502 |
|---|---|
| Minimum | 1 |
| Maximum | 424 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 1005.1 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 10 |
| Q1 | 50 |
| median | 152 |
| Q3 | 274 |
| 95-th percentile | 340 |
| Maximum | 424 |
| Range | 423 |
| Interquartile range (IQR) | 224 |
Descriptive statistics
| Standard deviation | 115.8440477 |
|---|---|
| Coefficient of variation (CV) | 0.6966400555 |
| Kurtosis | -1.342787683 |
| Mean | 166.2896739 |
| Median Absolute Deviation (MAD) | 111 |
| Skewness | 0.1960464794 |
| Sum | 21393998 |
| Variance | 13419.84338 |
| Value | Count | Frequency (%) | |
| 24 | 4474 | 3.5% | |
| 199 | 4194 | 3.3% | |
| 50 | 2842 | 2.2% | |
| 166 | 2381 | 1.9% | |
| 202 | 2208 | 1.7% | |
| 204 | 2126 | 1.7% | |
| 263 | 2104 | 1.6% | |
| 9 | 2012 | 1.6% | |
| 47 | 1952 | 1.5% | |
| 133 | 1939 | 1.5% | |
| Other values (179) | 102423 | 79.6% |
| Value | Count | Frequency (%) | |
| 1 | 621 | 0.5% | |
| 3 | 824 | 0.6% | |
| 5 | 1135 | 0.9% | |
| 6 | 666 | 0.5% | |
| 8 | 890 | 0.7% |
| Value | Count | Frequency (%) | |
| 424 | 19 | < 0.1% | |
| 423 | 122 | 0.1% | |
| 421 | 8 | < 0.1% | |
| 418 | 28 | < 0.1% | |
| 416 | 9 | < 0.1% |
| Distinct count | 92 |
|---|---|
| Unique (%) | 0.1% |
| Missing | 11653 |
| Missing (%) | 9.1% |
| Memory size | 1005.1 KiB |
| LUCKNOW | 9337 |
|---|---|
| SIRSA | 6575 |
| NELLORE | 5859 |
| KANPUR | 4573 |
| INDORE | 4024 |
| Other values (87) |
| Value | Count | Frequency (%) | |
| LUCKNOW | 9337 | 7.3% | |
| SIRSA | 6575 | 5.1% | |
| NELLORE | 5859 | 4.6% | |
| KANPUR | 4573 | 3.6% | |
| INDORE | 4024 | 3.1% | |
| MIRYALGUDA | 3978 | 3.1% | |
| JAIPUR | 3724 | 2.9% | |
| SINDHANUR | 3719 | 2.9% | |
| AHMEDABAD AMBAVADI | 3654 | 2.8% | |
| JABALPUR | 3534 | 2.7% | |
| Other values (82) | 68025 | 52.9% | |
| (Missing) | 11653 | 9.1% |
Length
| Max length | 28 |
|---|---|
| Median length | 7 |
| Mean length | 7.974326688 |
| Min length | 3 |
Tenure
Real number (ℝ≥0)
| Distinct count | 141 |
|---|---|
| Unique (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 42.46477789436866 |
|---|---|
| Minimum | 5 |
| Maximum | 501 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 1005.1 KiB |
Quantile statistics
| Minimum | 5 |
|---|---|
| 5-th percentile | 22 |
| Q1 | 36 |
| median | 36 |
| Q3 | 48 |
| 95-th percentile | 60 |
| Maximum | 501 |
| Range | 496 |
| Interquartile range (IQR) | 12 |
Descriptive statistics
| Standard deviation | 23.53397173 |
|---|---|
| Coefficient of variation (CV) | 0.5541998074 |
| Kurtosis | 53.56308226 |
| Mean | 42.46477789 |
| Median Absolute Deviation (MAD) | 12 |
| Skewness | 6.02575669 |
| Sum | 5463306 |
| Variance | 553.8478255 |
| Value | Count | Frequency (%) | |
| 36 | 36977 | 28.7% | |
| 48 | 25672 | 20.0% | |
| 24 | 14327 | 11.1% | |
| 60 | 12209 | 9.5% | |
| 42 | 4864 | 3.8% | |
| 12 | 3482 | 2.7% | |
| 54 | 2075 | 1.6% | |
| 33 | 2022 | 1.6% | |
| 30 | 2008 | 1.6% | |
| 35 | 1817 | 1.4% | |
| Other values (131) | 23202 | 18.0% |
| Value | Count | Frequency (%) | |
| 5 | 2 | < 0.1% | |
| 6 | 6 | < 0.1% | |
| 7 | 4 | < 0.1% | |
| 8 | 5 | < 0.1% | |
| 9 | 16 | < 0.1% |
| Value | Count | Frequency (%) | |
| 501 | 1 | < 0.1% | |
| 354 | 1 | < 0.1% | |
| 342 | 3 | < 0.1% | |
| 336 | 5 | < 0.1% | |
| 330 | 21 | < 0.1% |
AssetCost
Real number (ℝ≥0)
| Distinct count | 7835 |
|---|---|
| Unique (%) | 6.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 555024.6847926625 |
|---|---|
| Minimum | 200000 |
| Maximum | 2250000 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 1005.1 KiB |
Quantile statistics
| Minimum | 200000 |
|---|---|
| 5-th percentile | 388000 |
| Q1 | 500000 |
| median | 550735 |
| Q3 | 611000 |
| 95-th percentile | 700000 |
| Maximum | 2250000 |
| Range | 2050000 |
| Interquartile range (IQR) | 111000 |
Descriptive statistics
| Standard deviation | 108303.551 |
|---|---|
| Coefficient of variation (CV) | 0.1951328543 |
| Kurtosis | 21.54192698 |
| Mean | 555024.6848 |
| Median Absolute Deviation (MAD) | 55735 |
| Skewness | 1.912221804 |
| Sum | 7.140670082e+10 |
| Variance | 1.172965915e+10 |
| Value | Count | Frequency (%) | |
| 550000 | 5648 | 4.4% | |
| 600000 | 4594 | 3.6% | |
| 500000 | 4413 | 3.4% | |
| 560000 | 3992 | 3.1% | |
| 580000 | 3630 | 2.8% | |
| 530000 | 3329 | 2.6% | |
| 540000 | 3209 | 2.5% | |
| 650000 | 3146 | 2.4% | |
| 520000 | 2985 | 2.3% | |
| 570000 | 2747 | 2.1% | |
| Other values (7825) | 90962 | 70.7% |
| Value | Count | Frequency (%) | |
| 200000 | 1 | < 0.1% | |
| 210000 | 2 | < 0.1% | |
| 215000 | 1 | < 0.1% | |
| 218215 | 1 | < 0.1% | |
| 219000 | 3 | < 0.1% |
| Value | Count | Frequency (%) | |
| 2250000 | 1 | < 0.1% | |
| 2221888 | 1 | < 0.1% | |
| 2199525 | 1 | < 0.1% | |
| 2180000 | 1 | < 0.1% | |
| 2178750 | 1 | < 0.1% |
| Distinct count | 20439 |
|---|---|
| Unique (%) | 15.9% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 348309.63386576495 |
|---|---|
| Minimum | 50000.0 |
| Maximum | 1308351.0 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 1005.1 KiB |
Quantile statistics
| Minimum | 50000 |
|---|---|
| 5-th percentile | 195000 |
| Q1 | 290000 |
| median | 350000 |
| Q3 | 410000 |
| 95-th percentile | 503644.154 |
| Maximum | 1308351 |
| Range | 1258351 |
| Interquartile range (IQR) | 120000 |
Descriptive statistics
| Standard deviation | 105545.3424 |
|---|---|
| Coefficient of variation (CV) | 0.3030215996 |
| Kurtosis | 2.427430198 |
| Mean | 348309.6339 |
| Median Absolute Deviation (MAD) | 60000 |
| Skewness | 0.4365686939 |
| Sum | 4.481177594e+10 |
| Variance | 1.11398193e+10 |
| Value | Count | Frequency (%) | |
| 300000 | 14063 | 10.9% | |
| 400000 | 9016 | 7.0% | |
| 350000 | 7651 | 5.9% | |
| 200000 | 6896 | 5.4% | |
| 250000 | 5149 | 4.0% | |
| 450000 | 3094 | 2.4% | |
| 500000 | 2489 | 1.9% | |
| 150000 | 1646 | 1.3% | |
| 380000 | 1469 | 1.1% | |
| 370000 | 1414 | 1.1% | |
| Other values (20429) | 75768 | 58.9% |
| Value | Count | Frequency (%) | |
| 50000 | 1 | < 0.1% | |
| 55000 | 1 | < 0.1% | |
| 70000 | 1 | < 0.1% | |
| 75000 | 1 | < 0.1% | |
| 80000 | 3 | < 0.1% |
| Value | Count | Frequency (%) | |
| 1308351 | 1 | < 0.1% | |
| 1302822 | 1 | < 0.1% | |
| 1300000 | 2 | < 0.1% | |
| 1275000 | 1 | < 0.1% | |
| 1257239 | 1 | < 0.1% |
| Distinct count | 19412 |
|---|---|
| Unique (%) | 15.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 347930.56846465357 |
|---|---|
| Minimum | 2894.0 |
| Maximum | 1308351.0 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 1005.1 KiB |
Quantile statistics
| Minimum | 2894 |
|---|---|
| 5-th percentile | 195000 |
| Q1 | 290000 |
| median | 350000 |
| Q3 | 410000 |
| 95-th percentile | 503035.3 |
| Maximum | 1308351 |
| Range | 1305457 |
| Interquartile range (IQR) | 120000 |
Descriptive statistics
| Standard deviation | 105319.8355 |
|---|---|
| Coefficient of variation (CV) | 0.3027035996 |
| Kurtosis | 2.454799098 |
| Mean | 347930.5685 |
| Median Absolute Deviation (MAD) | 60000 |
| Skewness | 0.4323927592 |
| Sum | 4.476300729e+10 |
| Variance | 1.109226774e+10 |
| Value | Count | Frequency (%) | |
| 300000 | 14164 | 11.0% | |
| 400000 | 9147 | 7.1% | |
| 350000 | 7706 | 6.0% | |
| 200000 | 6943 | 5.4% | |
| 250000 | 5175 | 4.0% | |
| 450000 | 3149 | 2.4% | |
| 500000 | 2550 | 2.0% | |
| 150000 | 1657 | 1.3% | |
| 380000 | 1483 | 1.2% | |
| 370000 | 1424 | 1.1% | |
| Other values (19402) | 75257 | 58.5% |
| Value | Count | Frequency (%) | |
| 2894 | 1 | < 0.1% | |
| 3000 | 1 | < 0.1% | |
| 4063 | 1 | < 0.1% | |
| 5574 | 1 | < 0.1% | |
| 9503 | 1 | < 0.1% |
| Value | Count | Frequency (%) | |
| 1308351 | 1 | < 0.1% | |
| 1302822 | 1 | < 0.1% | |
| 1300000 | 2 | < 0.1% | |
| 1275000 | 1 | < 0.1% | |
| 1257239 | 1 | < 0.1% |
EMI
Real number (ℝ≥0)
| Distinct count | 24323 |
|---|---|
| Unique (%) | 18.9% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 55072.75850600443 |
|---|---|
| Minimum | 0.0 |
| Maximum | 460000.0 |
| Zeros | 1 |
| Zeros (%) | < 0.1% |
| Memory size | 1005.1 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 10484.7 |
| Q1 | 32500 |
| median | 59700 |
| Q3 | 73800 |
| 95-th percentile | 97950 |
| Maximum | 460000 |
| Range | 460000 |
| Interquartile range (IQR) | 41300 |
Descriptive statistics
| Standard deviation | 28910.11174 |
|---|---|
| Coefficient of variation (CV) | 0.5249439564 |
| Kurtosis | 3.740022756 |
| Mean | 55072.75851 |
| Median Absolute Deviation (MAD) | 19743 |
| Skewness | 0.6874947937 |
| Sum | 7085385746 |
| Variance | 835794560.8 |
| Value | Count | Frequency (%) | |
| 20000 | 1911 | 1.5% | |
| 30000 | 1864 | 1.4% | |
| 25000 | 1399 | 1.1% | |
| 50000 | 1235 | 1.0% | |
| 15000 | 988 | 0.8% | |
| 60000 | 956 | 0.7% | |
| 40000 | 937 | 0.7% | |
| 65000 | 927 | 0.7% | |
| 10000 | 919 | 0.7% | |
| 75000 | 894 | 0.7% | |
| Other values (24313) | 116625 | 90.6% |
| Value | Count | Frequency (%) | |
| 0 | 1 | < 0.1% | |
| 100 | 1 | < 0.1% | |
| 200 | 1 | < 0.1% | |
| 300 | 1 | < 0.1% | |
| 370 | 1 | < 0.1% |
| Value | Count | Frequency (%) | |
| 460000 | 1 | < 0.1% | |
| 450000 | 1 | < 0.1% | |
| 430000 | 1 | < 0.1% | |
| 390000 | 1 | < 0.1% | |
| 389700 | 1 | < 0.1% |
DisbursalDate
Date
| Distinct count | 2837 |
|---|---|
| Unique (%) | 2.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1005.1 KiB |
| Minimum | 2010-02-01 00:00:00 |
|---|---|
| Maximum | 2019-11-23 00:00:00 |
MaturityDAte
Date
| Distinct count | 980 |
|---|---|
| Unique (%) | 0.8% |
| Missing | 1 |
| Missing (%) | < 0.1% |
| Memory size | 1005.1 KiB |
| Minimum | 2010-11-15 00:00:00 |
|---|---|
| Maximum | 2059-08-10 00:00:00 |
AuthDate
Date
| Distinct count | 2711 |
|---|---|
| Unique (%) | 2.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1005.1 KiB |
| Minimum | 2010-02-03 00:00:00 |
|---|---|
| Maximum | 2019-11-23 00:00:00 |
| Distinct count | 128655 |
|---|---|
| Unique (%) | 100.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 16397728.99015973 |
|---|---|
| Minimum | 422271 |
| Maximum | 37066666 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 1005.1 KiB |
Quantile statistics
| Minimum | 422271 |
|---|---|
| 5-th percentile | 910238.8 |
| Q1 | 9438948.5 |
| median | 15133927 |
| Q3 | 25333957.5 |
| 95-th percentile | 30298259 |
| Maximum | 37066666 |
| Range | 36644395 |
| Interquartile range (IQR) | 15895009 |
Descriptive statistics
| Standard deviation | 9539540.249 |
|---|---|
| Coefficient of variation (CV) | 0.5817598434 |
| Kurtosis | -1.130064666 |
| Mean | 16397728.99 |
| Median Absolute Deviation (MAD) | 9005918 |
| Skewness | -0.09448442021 |
| Sum | 2.109649823e+12 |
| Variance | 9.100282816e+13 |
| Value | Count | Frequency (%) | |
| 14425238 | 1 | < 0.1% | |
| 26856210 | 1 | < 0.1% | |
| 432888 | 1 | < 0.1% | |
| 25671318 | 1 | < 0.1% | |
| 14094476 | 1 | < 0.1% | |
| 23157504 | 1 | < 0.1% | |
| 5853953 | 1 | < 0.1% | |
| 24462083 | 1 | < 0.1% | |
| 8485636 | 1 | < 0.1% | |
| 27095813 | 1 | < 0.1% | |
| Other values (128645) | 128645 | > 99.9% |
| Value | Count | Frequency (%) | |
| 422271 | 1 | < 0.1% | |
| 422403 | 1 | < 0.1% | |
| 422562 | 1 | < 0.1% | |
| 423130 | 1 | < 0.1% | |
| 423152 | 1 | < 0.1% |
| Value | Count | Frequency (%) | |
| 37066666 | 1 | < 0.1% | |
| 36977268 | 1 | < 0.1% | |
| 36944610 | 1 | < 0.1% | |
| 36820837 | 1 | < 0.1% | |
| 36762642 | 1 | < 0.1% |
ManufacturerID
Real number (ℝ≥0)
| Distinct count | 10 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1171.3272706074385 |
|---|---|
| Minimum | 1019 |
| Maximum | 3473 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 1005.1 KiB |
Quantile statistics
| Minimum | 1019 |
|---|---|
| 5-th percentile | 1019 |
| Q1 | 1046 |
| median | 1062 |
| Q3 | 1186 |
| 95-th percentile | 1568 |
| Maximum | 3473 |
| Range | 2454 |
| Interquartile range (IQR) | 140 |
Descriptive statistics
| Standard deviation | 257.7902082 |
|---|---|
| Coefficient of variation (CV) | 0.2200838439 |
| Kurtosis | 37.64662117 |
| Mean | 1171.327271 |
| Median Absolute Deviation (MAD) | 43 |
| Skewness | 5.071646502 |
| Sum | 150697110 |
| Variance | 66455.79143 |
| Value | Count | Frequency (%) | |
| 1046 | 25304 | 19.7% | |
| 1186 | 23797 | 18.5% | |
| 1062 | 18728 | 14.6% | |
| 1568 | 16320 | 12.7% | |
| 1060 | 15802 | 12.3% | |
| 1019 | 15386 | 12.0% | |
| 1187 | 12160 | 9.5% | |
| 3473 | 745 | 0.6% | |
| 2608 | 412 | 0.3% | |
| 2733 | 1 | < 0.1% |
| Value | Count | Frequency (%) | |
| 1019 | 15386 | 12.0% | |
| 1046 | 25304 | 19.7% | |
| 1060 | 15802 | 12.3% | |
| 1062 | 18728 | 14.6% | |
| 1186 | 23797 | 18.5% |
| Value | Count | Frequency (%) | |
| 3473 | 745 | 0.6% | |
| 2733 | 1 | < 0.1% | |
| 2608 | 412 | 0.3% | |
| 1568 | 16320 | 12.7% | |
| 1187 | 12160 | 9.5% |
SupplierID
Real number (ℝ≥0)
| Distinct count | 4539 |
|---|---|
| Unique (%) | 3.5% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 56551.226209630404 |
|---|---|
| Minimum | 5879 |
| Maximum | 145518 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 1005.1 KiB |
Quantile statistics
| Minimum | 5879 |
|---|---|
| 5-th percentile | 21701 |
| Q1 | 24093 |
| median | 39146 |
| Q3 | 87034 |
| 95-th percentile | 129070 |
| Maximum | 145518 |
| Range | 139639 |
| Interquartile range (IQR) | 62941 |
Descriptive statistics
| Standard deviation | 36399.35528 |
|---|---|
| Coefficient of variation (CV) | 0.6436528032 |
| Kurtosis | -0.7636344882 |
| Mean | 56551.22621 |
| Median Absolute Deviation (MAD) | 16195 |
| Skewness | 0.7704984845 |
| Sum | 7275598008 |
| Variance | 1324913065 |
| Value | Count | Frequency (%) | |
| 42707 | 1465 | 1.1% | |
| 29012 | 1301 | 1.0% | |
| 38832 | 1039 | 0.8% | |
| 89813 | 1004 | 0.8% | |
| 27328 | 735 | 0.6% | |
| 23968 | 735 | 0.6% | |
| 24390 | 634 | 0.5% | |
| 23388 | 598 | 0.5% | |
| 32708 | 584 | 0.5% | |
| 27361 | 526 | 0.4% | |
| Other values (4529) | 120034 | 93.3% |
| Value | Count | Frequency (%) | |
| 5879 | 46 | < 0.1% | |
| 20002 | 97 | 0.1% | |
| 20055 | 34 | < 0.1% | |
| 20060 | 7 | < 0.1% | |
| 20105 | 432 | 0.3% |
| Value | Count | Frequency (%) | |
| 145518 | 1 | < 0.1% | |
| 145194 | 1 | < 0.1% | |
| 144867 | 2 | < 0.1% | |
| 144858 | 1 | < 0.1% | |
| 144787 | 1 | < 0.1% |
LTV
Real number (ℝ)
| Distinct count | 7988 |
|---|---|
| Unique (%) | 6.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 59.12622571994871 |
|---|---|
| Minimum | -1.38 |
| Maximum | 100.0 |
| Zeros | 1 |
| Zeros (%) | < 0.1% |
| Memory size | 1005.1 KiB |
Quantile statistics
| Minimum | -1.38 |
|---|---|
| 5-th percentile | 30.747 |
| Q1 | 49.14 |
| median | 60.78 |
| Q3 | 70.59 |
| 95-th percentile | 81.82 |
| Maximum | 100 |
| Range | 101.38 |
| Interquartile range (IQR) | 21.45 |
Descriptive statistics
| Standard deviation | 15.53903766 |
|---|---|
| Coefficient of variation (CV) | 0.2628112563 |
| Kurtosis | -0.1455309886 |
| Mean | 59.12622572 |
| Median Absolute Deviation (MAD) | 10.65 |
| Skewness | -0.4553036387 |
| Sum | 7606884.57 |
| Variance | 241.4616914 |
| Value | Count | Frequency (%) | |
| 66.67 | 972 | 0.8% | |
| 80 | 707 | 0.5% | |
| 62.5 | 604 | 0.5% | |
| 71.43 | 592 | 0.5% | |
| 50 | 576 | 0.4% | |
| 75 | 571 | 0.4% | |
| 60 | 551 | 0.4% | |
| 70 | 546 | 0.4% | |
| 55.56 | 494 | 0.4% | |
| 72.73 | 427 | 0.3% | |
| Other values (7978) | 122615 | 95.3% |
| Value | Count | Frequency (%) | |
| -1.38 | 1 | < 0.1% | |
| 0 | 1 | < 0.1% | |
| 1.45 | 1 | < 0.1% | |
| 1.92 | 1 | < 0.1% | |
| 5.22 | 1 | < 0.1% |
| Value | Count | Frequency (%) | |
| 100 | 1 | < 0.1% | |
| 99.46 | 1 | < 0.1% | |
| 98.7 | 1 | < 0.1% | |
| 98.63 | 1 | < 0.1% | |
| 98.52 | 1 | < 0.1% |
SEX
Categorical
| Distinct count | 2 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 59 |
| Missing (%) | < 0.1% |
| Memory size | 1005.1 KiB |
| M | |
|---|---|
| F | 6452 |
| Value | Count | Frequency (%) | |
| M | 122144 | 94.9% | |
| F | 6452 | 5.0% | |
| (Missing) | 59 | < 0.1% |
Length
| Max length | 3 |
|---|---|
| Median length | 1 |
| Mean length | 1.000917182 |
| Min length | 1 |
AGE
Real number (ℝ≥0)
| Distinct count | 73 |
|---|---|
| Unique (%) | 0.1% |
| Missing | 59 |
| Missing (%) | < 0.1% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 40.66480294876979 |
|---|---|
| Minimum | 18.0 |
| Maximum | 90.0 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 1005.1 KiB |
Quantile statistics
| Minimum | 18 |
|---|---|
| 5-th percentile | 23 |
| Q1 | 31 |
| median | 40 |
| Q3 | 49 |
| 95-th percentile | 61 |
| Maximum | 90 |
| Range | 72 |
| Interquartile range (IQR) | 18 |
Descriptive statistics
| Standard deviation | 11.71284679 |
|---|---|
| Coefficient of variation (CV) | 0.2880340229 |
| Kurtosis | -0.4793653823 |
| Mean | 40.66480295 |
| Median Absolute Deviation (MAD) | 9 |
| Skewness | 0.3491376672 |
| Sum | 5229331 |
| Variance | 137.1907798 |
| Value | Count | Frequency (%) | |
| 35 | 3926 | 3.1% | |
| 40 | 3918 | 3.0% | |
| 33 | 3908 | 3.0% | |
| 37 | 3889 | 3.0% | |
| 34 | 3889 | 3.0% | |
| 41 | 3855 | 3.0% | |
| 36 | 3848 | 3.0% | |
| 38 | 3834 | 3.0% | |
| 39 | 3739 | 2.9% | |
| 31 | 3695 | 2.9% | |
| Other values (63) | 90095 | 70.0% |
| Value | Count | Frequency (%) | |
| 18 | 228 | 0.2% | |
| 19 | 562 | 0.4% | |
| 20 | 941 | 0.7% | |
| 21 | 1419 | 1.1% | |
| 22 | 1756 | 1.4% |
| Value | Count | Frequency (%) | |
| 90 | 1 | < 0.1% | |
| 89 | 1 | < 0.1% | |
| 88 | 1 | < 0.1% | |
| 87 | 1 | < 0.1% | |
| 86 | 2 | < 0.1% |
| Distinct count | 11568 |
|---|---|
| Unique (%) | 9.0% |
| Missing | 234 |
| Missing (%) | 0.2% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 50323.60434087884 |
|---|---|
| Minimum | 0.0 |
| Maximum | 617477500.0 |
| Zeros | 27 |
| Zeros (%) | < 0.1% |
| Memory size | 1005.1 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 13250 |
| Q1 | 25000 |
| median | 35833.33 |
| Q3 | 50000 |
| 95-th percentile | 92923.33 |
| Maximum | 617477500 |
| Range | 617477500 |
| Interquartile range (IQR) | 25000 |
Descriptive statistics
| Standard deviation | 1724607.365 |
|---|---|
| Coefficient of variation (CV) | 34.27034664 |
| Kurtosis | 127926.2107 |
| Mean | 50323.60434 |
| Median Absolute Deviation (MAD) | 11666.66 |
| Skewness | 357.3273301 |
| Sum | 6462607593 |
| Variance | 2.974270562e+12 |
| Value | Count | Frequency (%) | |
| 41666.67 | 9609 | 7.5% | |
| 25000 | 8759 | 6.8% | |
| 33333.33 | 8592 | 6.7% | |
| 50000 | 5441 | 4.2% | |
| 29166.67 | 4406 | 3.4% | |
| 16666.67 | 4151 | 3.2% | |
| 20833.33 | 3350 | 2.6% | |
| 37500 | 3344 | 2.6% | |
| 58333.33 | 2857 | 2.2% | |
| 66666.67 | 2061 | 1.6% | |
| Other values (11558) | 75851 | 59.0% |
| Value | Count | Frequency (%) | |
| 0 | 27 | < 0.1% | |
| 0.08 | 154 | 0.1% | |
| 0.17 | 50 | < 0.1% | |
| 0.25 | 8 | < 0.1% | |
| 0.33 | 6 | < 0.1% |
| Value | Count | Frequency (%) | |
| 617477500 | 1 | < 0.1% | |
| 11666666.67 | 1 | < 0.1% | |
| 7000000 | 1 | < 0.1% | |
| 6462000 | 1 | < 0.1% | |
| 5250000 | 1 | < 0.1% |
| Distinct count | 488 |
|---|---|
| Unique (%) | 0.4% |
| Missing | 11256 |
| Missing (%) | 8.7% |
| Memory size | 1005.1 KiB |
| NALGONDA | 2231 |
|---|---|
| HISAR | 1790 |
| GUNTUR | 1756 |
| NELLORE | 1634 |
| JODHPUR | 1632 |
| Other values (483) |
| Value | Count | Frequency (%) | |
| NALGONDA | 2231 | 1.7% | |
| HISAR | 1790 | 1.4% | |
| GUNTUR | 1756 | 1.4% | |
| NELLORE | 1634 | 1.3% | |
| JODHPUR | 1632 | 1.3% | |
| BHIWANI | 1535 | 1.2% | |
| MANDSAUR | 1507 | 1.2% | |
| KARIMNAGAR | 1481 | 1.2% | |
| RAICHUR | 1423 | 1.1% | |
| KHAMMAM | 1335 | 1.0% | |
| Other values (478) | 101075 | 78.6% | |
| (Missing) | 11256 | 8.7% |
Length
| Max length | 26 |
|---|---|
| Median length | 7 |
| Mean length | 7.203264545 |
| Min length | 1 |
State
Categorical
| Distinct count | 22 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1005.1 KiB |
| MADHYA PRADESH | |
|---|---|
| ANDHRA PRADESH | |
| UTTAR PRADESH | |
| KARNATAKA | |
| GUJARAT | 10088 |
| Other values (17) |
| Value | Count | Frequency (%) | |
| MADHYA PRADESH | 19122 | 14.9% | |
| ANDHRA PRADESH | 18629 | 14.5% | |
| UTTAR PRADESH | 14449 | 11.2% | |
| KARNATAKA | 11569 | 9.0% | |
| GUJARAT | 10088 | 7.8% | |
| RAJASTHAN | 9668 | 7.5% | |
| MAHARASHTRA | 9083 | 7.1% | |
| HARYANA | 9060 | 7.0% | |
| PUNJAB | 6420 | 5.0% | |
| WEST BENGAL | 5557 | 4.3% | |
| Other values (12) | 15010 | 11.7% |
Length
| Max length | 22 |
|---|---|
| Median length | 11 |
| Mean length | 10.59959582 |
| Min length | 5 |
ZiPCODE
Real number (ℝ≥0)
| Distinct count | 9123 |
|---|---|
| Unique (%) | 7.1% |
| Missing | 372 |
| Missing (%) | 0.3% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 427931.09972482716 |
|---|---|
| Minimum | 110000.0 |
| Maximum | 855456.0 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 1005.1 KiB |
Quantile statistics
| Minimum | 110000 |
|---|---|
| 5-th percentile | 127021 |
| Q1 | 304804 |
| median | 458553 |
| Q3 | 521131 |
| 95-th percentile | 752100.9 |
| Maximum | 855456 |
| Range | 745456 |
| Interquartile range (IQR) | 216327 |
Descriptive statistics
| Standard deviation | 175704.364 |
|---|---|
| Coefficient of variation (CV) | 0.4105903127 |
| Kurtosis | -0.2735939009 |
| Mean | 427931.0997 |
| Median Absolute Deviation (MAD) | 97393 |
| Skewness | 0.07648527142 |
| Sum | 5.489628527e+10 |
| Variance | 3.087202354e+10 |
| Value | Count | Frequency (%) | |
| 125001 | 806 | 0.6% | |
| 125055 | 690 | 0.5% | |
| 584128 | 524 | 0.4% | |
| 125050 | 409 | 0.3% | |
| 334001 | 407 | 0.3% | |
| 342301 | 403 | 0.3% | |
| 342303 | 395 | 0.3% | |
| 464228 | 363 | 0.3% | |
| 261001 | 350 | 0.3% | |
| 495001 | 348 | 0.3% | |
| Other values (9113) | 123588 | 96.1% | |
| (Missing) | 372 | 0.3% |
| Value | Count | Frequency (%) | |
| 110000 | 1 | < 0.1% | |
| 110003 | 1 | < 0.1% | |
| 110012 | 1 | < 0.1% | |
| 110016 | 1 | < 0.1% | |
| 110036 | 1 | < 0.1% |
| Value | Count | Frequency (%) | |
| 855456 | 1 | < 0.1% | |
| 855117 | 8 | < 0.1% | |
| 855116 | 7 | < 0.1% | |
| 855115 | 7 | < 0.1% | |
| 855114 | 9 | < 0.1% |
Top-up Month
Categorical
| Distinct count | 7 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1005.1 KiB |
| No Top-up Service | |
|---|---|
| > 48 Months | 8366 |
| 36-48 Months | 3656 |
| 24-30 Months | 3492 |
| 30-36 Months | 3062 |
| Other values (2) | 3402 |
| Value | Count | Frequency (%) | |
| No Top-up Service | 106677 | 82.9% | |
| > 48 Months | 8366 | 6.5% | |
| 36-48 Months | 3656 | 2.8% | |
| 24-30 Months | 3492 | 2.7% | |
| 30-36 Months | 3062 | 2.4% | |
| 18-24 Months | 2368 | 1.8% | |
| 12-18 Months | 1034 | 0.8% |
Length
| Max length | 17 |
|---|---|
| Median length | 17 |
| Mean length | 16.14585519 |
| Min length | 12 |
Pearson's r
The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.
Spearman's ρ
The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.
Kendall's τ
Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.
Phik (φk)
Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.Cramér's V (φc)
Cramér's V is an association measure for nominal random variables. The coefficient ranges from 0 to 1, with 0 indicating independence and 1 indicating perfect association. The empirical estimators used for Cramér's V have been proved to be biased, even for large samples. We use a bias-corrected measure that has been proposed by Bergsma in 2013 that can be found here.First rows
| ID | Frequency | InstlmentMode | LoanStatus | PaymentMode | BranchID | Area | Tenure | AssetCost | AmountFinance | DisbursalAmount | EMI | DisbursalDate | MaturityDAte | AuthDate | AssetID | ManufacturerID | SupplierID | LTV | SEX | AGE | MonthlyIncome | City | State | ZiPCODE | Top-up Month | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 1 | Monthly | Arrear | Closed | PDC_E | 1 | NaN | 48 | 450000 | 275000.0 | 275000.0 | 24000.0 | 2012-02-10 | 2016-01-15 | 2012-02-10 | 4022465 | 1568 | 21946 | 61.11 | M | 49.0 | 35833.33 | RAISEN | MADHYA PRADESH | 464993.0 | > 48 Months |
| 1 | 2 | Monthly | Advance | Closed | PDC | 333 | BHOPAL | 47 | 485000 | 350000.0 | 350000.0 | 10500.0 | 2012-03-31 | 2016-02-15 | 2012-03-31 | 4681175 | 1062 | 34802 | 70.00 | M | 23.0 | 666.67 | SEHORE | MADHYA PRADESH | 466001.0 | No Top-up Service |
| 2 | 3 | Quatrly | Arrear | Active | Direct Debit | 1 | NaN | 68 | 690000 | 519728.0 | 519728.0 | 38300.0 | 2017-06-17 | 2023-02-10 | 2017-06-17 | 25328146 | 1060 | 127335 | 69.77 | M | 39.0 | 45257.00 | BHOPAL | MADHYA PRADESH | 462030.0 | 12-18 Months |
| 3 | 7 | Monthly | Advance | Closed | Billed | 125 | GUNA | 48 | 480000 | 400000.0 | 400000.0 | 11600.0 | 2013-11-29 | 2017-11-10 | 2013-11-29 | 13021591 | 1060 | 25094 | 80.92 | M | 24.0 | 20833.33 | ASHOK NAGAR | MADHYA PRADESH | 473335.0 | > 48 Months |
| 4 | 8 | Monthly | Arrear | Closed | Billed | 152 | BILASPUR | 44 | 619265 | 440000.0 | 440000.0 | 15000.0 | 2011-12-08 | 2015-07-05 | 2011-12-08 | 3291320 | 1046 | 21853 | 71.05 | M | 56.0 | 27313.67 | BILASPUR | CHATTISGARH | 495442.0 | 36-48 Months |
| 5 | 9 | Monthly | Arrear | Closed | Billed | 5 | RAIPUR | 48 | 400000 | 280000.0 | 280000.0 | 53000.0 | 2011-12-19 | 2015-12-15 | 2011-12-19 | 3413012 | 1019 | 54689 | 70.00 | M | 40.0 | 42083.33 | RAIPUR | CHATTISGARH | 493885.0 | No Top-up Service |
| 6 | 10 | Monthly | Arrear | Closed | PDC_E | 5 | RAIPUR | 48 | 716000 | 450000.0 | 450000.0 | 2000.0 | 2011-12-31 | 2015-12-05 | 2011-12-31 | 3553579 | 1019 | 54689 | 62.85 | M | 23.0 | 46221.00 | RAIPUR | CHATTISGARH | 493889.0 | No Top-up Service |
| 7 | 11 | Monthly | Arrear | Closed | PDC_E | 5 | RAIPUR | 48 | 600000 | 360000.0 | 360000.0 | 11000.0 | 2012-02-09 | 2016-02-15 | 2012-02-09 | 4008234 | 1187 | 21232 | 60.00 | M | 41.0 | 46195.08 | RAIPUR | CHATTISGARH | 493114.0 | No Top-up Service |
| 8 | 12 | Monthly | Arrear | Closed | PDC | 5 | RAIPUR | 46 | 539275 | 400000.0 | 400000.0 | 50000.0 | 2012-03-29 | 2016-01-15 | 2012-03-29 | 4603217 | 1046 | 24760 | 74.17 | M | 51.0 | 15000.00 | RAIPUR | CHATTISGARH | 493196.0 | No Top-up Service |
| 9 | 13 | Monthly | Arrear | Closed | PDC | 5 | RAIPUR | 48 | 689275 | 490000.0 | 490000.0 | 10000.0 | 2012-03-30 | 2016-02-15 | 2012-03-30 | 4619836 | 1046 | 24760 | 71.09 | M | 33.0 | 31666.67 | RAIPUR | CHATTISGARH | 493344.0 | No Top-up Service |
Last rows
| ID | Frequency | InstlmentMode | LoanStatus | PaymentMode | BranchID | Area | Tenure | AssetCost | AmountFinance | DisbursalAmount | EMI | DisbursalDate | MaturityDAte | AuthDate | AssetID | ManufacturerID | SupplierID | LTV | SEX | AGE | MonthlyIncome | City | State | ZiPCODE | Top-up Month | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 128645 | 143385 | Half Yearly | Arrear | Active | Direct Debit | 414 | PALWAL | 24 | 450000 | 200000.0 | 200000.0 | 60248.0 | 2018-11-13 | 2020-11-05 | 2018-11-13 | 32009983 | 1568 | 105300 | 31.06 | M | 47.0 | 38083.33 | FARIDABAD | HARYANA | 121106.0 | No Top-up Service |
| 128646 | 143386 | Quatrly | Arrear | Active | Direct Debit | 414 | PALWAL | 24 | 350000 | 200000.0 | 200000.0 | 29268.0 | 2018-11-13 | 2020-10-05 | 2018-11-13 | 32010196 | 1568 | 105300 | 57.14 | M | 24.0 | 42000.00 | FARIDABAD | HARYANA | 121105.0 | No Top-up Service |
| 128647 | 143387 | Half Yearly | Arrear | Active | Direct Debit | 414 | PALWAL | 30 | 490000 | 250373.0 | 250373.0 | 75100.0 | 2018-11-14 | 2020-12-05 | 2018-11-15 | 32025240 | 1568 | 136126 | 35.69 | M | 43.0 | 38333.33 | GURGAON | HARYANA | 122103.0 | 12-18 Months |
| 128648 | 143388 | Quatrly | Arrear | Active | Direct Debit | 414 | PALWAL | 24 | 350000 | 200000.0 | 200000.0 | 29217.0 | 2019-01-30 | 2020-12-05 | 2019-01-30 | 33047682 | 1568 | 139068 | 57.14 | M | 51.0 | 34150.00 | FARIDABAD | HARYANA | 121103.0 | 18-24 Months |
| 128649 | 143389 | Quatrly | Arrear | Closed | Direct Debit | 416 | MANDLA | 12 | 650000 | 200000.0 | 200000.0 | 54370.0 | 2019-01-18 | 2019-12-05 | 2019-01-18 | 32884728 | 1568 | 85912 | 30.77 | M | 39.0 | 69083.33 | MANDLA | MADHYA PRADESH | 481661.0 | 18-24 Months |
| 128650 | 143390 | Half Yearly | Arrear | Closed | Direct Debit | 424 | PANIPAT | 24 | 470000 | 265601.0 | 265601.0 | 76800.0 | 2018-09-21 | 2020-06-05 | 2018-09-22 | 31286914 | 1568 | 48879 | 40.17 | M | 25.0 | 65333.33 | SONIPAT | HARYANA | 131403.0 | 24-30 Months |
| 128651 | 143391 | Half Yearly | Arrear | Closed | Direct Debit | 424 | PANIPAT | 24 | 460000 | 275630.0 | 275630.0 | 80100.0 | 2018-09-22 | 2020-06-05 | 2018-09-22 | 31295422 | 1568 | 48879 | 59.92 | M | 25.0 | 83333.33 | SONIPAT | HARYANA | 131403.0 | No Top-up Service |
| 128652 | 143393 | Monthly | Arrear | Active | Direct Debit | 424 | PANIPAT | 23 | 545000 | 300733.0 | 300733.0 | 15277.0 | 2018-11-23 | 2020-11-05 | 2018-11-23 | 32145629 | 1568 | 44118 | 52.38 | M | 36.0 | 248500.00 | SONIPAT | HARYANA | 131024.0 | No Top-up Service |
| 128653 | 143394 | Half Yearly | Arrear | Active | Direct Debit | 424 | PANIPAT | 35 | 350000 | 250962.0 | 250962.0 | 74341.0 | 2018-12-20 | 2021-06-05 | 2018-12-20 | 32509866 | 1568 | 48879 | 50.37 | M | 37.0 | 84500.00 | SONIPAT | HARYANA | 131103.0 | No Top-up Service |
| 128654 | 143395 | Half Yearly | Arrear | Active | Direct Debit | 424 | PANIPAT | 24 | 370000 | 200428.0 | 200428.0 | 59200.0 | 2018-12-31 | 2020-11-05 | 2018-12-31 | 32663754 | 1568 | 48879 | 54.17 | M | 33.0 | 178166.67 | SONIPAT | HARYANA | 131402.0 | No Top-up Service |